Section with comments and questions on the analysis and workflow - let’s mostly discuss here
We need to agree on names of positions in general and which fall into technical/non-technical groups.
I did some text mining and defined for now technical and non-technical positions manually looking at the resulting list without stop words. I decided to clasify as follows:
analy|special|engine|develop|technic|optimimanage|direct|writ|consult|coordinat|edito|market|sale|social|strateg|supervisI am not sure if all of them are correct (but hopefully most) but e.g. “specialist” is a term I would have another look at. I searched descriptions of specialists and they read as if SEO specialist is a common term for a technical position. Correct?
I thought I make a doughnut chart (as we also discussed on the phone). However, the doughnot looked not that good and a bit too fance - but on a caertesian coordinated these stacked bars looked very nice! So it’s a bit more fancy graph but I think that’s good for a bit of variety and atteention-drawing - I hope you and Brian like it!
With my new css/html skills it was an easy thing to change the boring colors and fonts to match backlinkos and our plot design ;)
We analysed the data on job titles using text mining techniques. In a first step, we tokenize the job titles into single words and visualize their frequency. Stop words and words that appeared less than 7 times were removed to make the graph easier to grasp.
In a second step, we analysed sequences of words in the job title. The sorted bar plot shows the most popular consecutive sequences of words (5 or more occurences), colored by category.
We manually classified in technical and non-technical positions, removing all words that are no specific to any of the both categories:
analy|special|engine|develop|technic|optimimanage|direct|writ|consult|coordinat|edito|market|sale|social|strateg|supervisThe modified stacked bar plot shows the number of words found per job category and, additionally as another stacked bar next to it, the most common words per category (with labels for words that occured at least 20 times). The height of the stacks indicates as well the number, the width is arbitrary.
(Not sure if specialist is technical only. I looked it up and it sounds as “SEO specialist” is a very technical position in general.)
How large are companies that hire?
Do larger companies require more specialized tasks?
Do larger companies require a formal education?
What programming languages are most often required?
What languages are most often required in combination (e.g. Html, CSS)